/*
MySQL Backup
Database: jlcon_myproject
Backup Time: 2021-10-18 14:53:09
*/

SET FOREIGN_KEY_CHECKS=0;
DROP TABLE IF EXISTS `jlcon_myproject`.`boss_user`;
DROP TABLE IF EXISTS `jlcon_myproject`.`problem_online`;
DROP TABLE IF EXISTS `jlcon_myproject`.`project`;
DROP TABLE IF EXISTS `jlcon_myproject`.`sys_menu`;
DROP TABLE IF EXISTS `jlcon_myproject`.`sys_param`;
DROP TABLE IF EXISTS `jlcon_myproject`.`sys_resource`;
DROP TABLE IF EXISTS `jlcon_myproject`.`sys_role`;
DROP TABLE IF EXISTS `jlcon_myproject`.`sys_role_resource`;
DROP TABLE IF EXISTS `jlcon_myproject`.`sys_short_cut`;
DROP TABLE IF EXISTS `jlcon_myproject`.`task`;
DROP TABLE IF EXISTS `jlcon_myproject`.`team_leave`;
DROP TABLE IF EXISTS `jlcon_myproject`.`user`;
CREATE TABLE `boss_user` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `user_name` varchar(20) DEFAULT NULL COMMENT '用户名',
  `password` varchar(100) DEFAULT NULL COMMENT '密码',
  `nick` varchar(20) DEFAULT NULL COMMENT '昵称/备注名',
  `phone` varchar(20) DEFAULT NULL COMMENT '电话号码',
  `is_locked` tinyint(1) DEFAULT '0' COMMENT '是否锁定',
  `user_role_id` bigint DEFAULT NULL COMMENT '外键-用户权限关系ID',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COMMENT='boss管理账号';
CREATE TABLE `problem_online` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `problem` varchar(255) DEFAULT NULL COMMENT '出现问题',
  `reason` varchar(255) DEFAULT NULL COMMENT '原因',
  `fix_man` varchar(255) DEFAULT NULL COMMENT '解决人',
  `solution_way` varchar(255) DEFAULT NULL COMMENT '解决方案',
  `start_time` timestamp NULL DEFAULT NULL COMMENT '故障开始时间',
  `end_time` timestamp NULL DEFAULT NULL COMMENT '故障解决时间',
  `plantform` varchar(20) DEFAULT NULL COMMENT '故障平台',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='线上故障信息';
CREATE TABLE `project` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '项目名称',
  `owner_type` enum('cmf','cqt') CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT 'cmf' COMMENT '项目所属',
  `start_time` timestamp NULL DEFAULT NULL COMMENT '项目开始时间',
  `is_enable` tinyint(1) DEFAULT '0' COMMENT '是否可用',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='项目信息';
CREATE TABLE `sys_menu` (
  `menu_id` bigint NOT NULL AUTO_INCREMENT,
  `parent_id` bigint DEFAULT NULL,
  `menu_name` varchar(50) NOT NULL COMMENT '菜单名字',
  `menu_icon` varchar(50) DEFAULT NULL COMMENT '菜单图标',
  `menu_url` varchar(255) DEFAULT NULL COMMENT '菜单链接',
  `leaf` enum('YES','NO') DEFAULT 'NO' COMMENT '是否叶子节点',
  `sort` int DEFAULT NULL,
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`menu_id`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8 COMMENT='系统菜单表';
CREATE TABLE `sys_param` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `param_name` varchar(50) DEFAULT NULL,
  `param_value` varchar(500) DEFAULT NULL,
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `sys_resource` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `parent_resource_id` bigint DEFAULT NULL COMMENT '父资源ID',
  `name` varchar(20) NOT NULL COMMENT '资源名称',
  `type` enum('operation','url') DEFAULT 'operation' COMMENT '资源类型',
  `permission` varchar(100) DEFAULT NULL COMMENT '资源代码',
  `url` varchar(255) DEFAULT NULL COMMENT '链接',
  `spread` tinyint(1) DEFAULT '0' COMMENT '节点是否初始展开，默认 false',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=86 DEFAULT CHARSET=utf8 COMMENT='系统资源信息';
CREATE TABLE `sys_role` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `role_name` varchar(20) NOT NULL COMMENT '权限名称',
  `role_code` varchar(20) DEFAULT NULL COMMENT '权限编码',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='系统权限信息';
CREATE TABLE `sys_role_resource` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `role_id` bigint DEFAULT NULL COMMENT '角色信息ID',
  `resource_id` bigint DEFAULT NULL COMMENT '资源信息ID',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=780 DEFAULT CHARSET=utf8 COMMENT='角色权限信息';
CREATE TABLE `sys_short_cut` (
  `short_cut_id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '自增序号',
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '快捷名称',
  `url` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '0' COMMENT '快捷地址',
  `enable` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否可用',
  `role_code` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '权限代码',
  `owner_type` enum('system','user') CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT 'user' COMMENT '快捷类型',
  `open_type` enum('system','linker') CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT 'system' COMMENT '链接类型',
  `ower_id` bigint DEFAULT NULL COMMENT '所属人ID',
  `icon` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT 'layui-icon-app' COMMENT '快捷图标',
  `sort` int DEFAULT NULL COMMENT '排序',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`short_cut_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='系统快捷';
CREATE TABLE `task` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `project_id` bigint DEFAULT NULL COMMENT '所属项目',
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '任务信息',
  `coder` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '开发人',
  `user_id` bigint DEFAULT NULL COMMENT '任务所属用户ID',
  `code_start` timestamp NULL DEFAULT NULL COMMENT '任务开始时间',
  `code_end` timestamp NULL DEFAULT NULL COMMENT '任务结束时间',
  `time_cost` float(10,2) DEFAULT NULL COMMENT '耗费工作日',
  `progress` float(10,0) DEFAULT '0' COMMENT '进度',
  `status` enum('run','finish','pending','cancel','plan') CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `pending_reson` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '挂起原因',
  `remark_task` text CHARACTER SET utf8 COLLATE utf8_unicode_ci COMMENT '任务备注',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=217 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='任务信息';
CREATE TABLE `team_leave` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `start_time` timestamp NULL DEFAULT NULL COMMENT '开始时间',
  `end_time` timestamp NULL DEFAULT NULL COMMENT '截止时间',
  `user_name` varchar(50) NOT NULL COMMENT '请假人',
  `leave_type` enum('huanxiu','nianjia','bingjia','normal') DEFAULT NULL,
  `reason` varchar(255) DEFAULT NULL COMMENT '请假事由',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8 COMMENT='请假信息';
CREATE TABLE `user` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `user_name` varchar(20) DEFAULT NULL COMMENT '用户名',
  `email` varchar(100) DEFAULT NULL COMMENT '公司邮箱',
  `password` varchar(100) DEFAULT NULL COMMENT '密码',
  `nick` varchar(20) DEFAULT NULL COMMENT '昵称/备注名',
  `position` varchar(50) DEFAULT NULL COMMENT '职位名称',
  `phone` varchar(20) DEFAULT NULL COMMENT '电话号码',
  `is_locked` enum('YES','NO') DEFAULT 'NO',
  `user_role_id` bigint DEFAULT NULL COMMENT '外键-用户权限关系ID',
  `person_status` enum('zaizhi','lizhi','chanjia','xiujia') DEFAULT 'zaizhi',
  `sex` enum('male','female') DEFAULT 'male',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COMMENT='用户账号';
BEGIN;
LOCK TABLES `jlcon_myproject`.`boss_user` WRITE;
DELETE FROM `jlcon_myproject`.`boss_user`;
INSERT INTO `jlcon_myproject`.`boss_user` (`id`,`user_name`,`password`,`nick`,`phone`,`is_locked`,`user_role_id`,`create_time`,`update_time`) VALUES (1, 'admin', '240be518fabd2724ddb6f04eeb1da5967448d7e831c08c8fa822809f74c720a9', 'Administrator', '15803061682', 0, 1, '2019-09-25 14:20:55', '2019-11-20 22:36:09'),(2, 'thinkergt', 'f7139c419b06dd3a9170a0558dffc0518f4de7c65b06400a4656df1481cb5f01', '关涛thinker', '13983138481', 0, 2, '2019-11-20 17:53:00', '2019-11-20 22:35:49'),(3, 'haozh', '8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92', '郝振华', '15010115080', 0, 3, '2019-11-21 17:30:22', '2019-11-21 17:30:22'),(4, 'tony', '8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92', '吴琪', '18501612455', 0, 3, '2019-12-04 16:03:36', '2019-12-15 13:17:52'),(6, 'lilq', '8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92', '李亮秋', '12121212121', 0, 4, '2019-12-11 09:55:01', '2019-12-11 09:55:15'),(7, 'zoulq', '8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92', '邹龙泉', '18618465389', 0, 3, '2019-12-13 14:54:00', '2019-12-13 14:54:00');
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `jlcon_myproject`.`problem_online` WRITE;
DELETE FROM `jlcon_myproject`.`problem_online`;
INSERT INTO `jlcon_myproject`.`problem_online` (`id`,`problem`,`reason`,`fix_man`,`solution_way`,`start_time`,`end_time`,`plantform`,`create_time`,`update_time`) VALUES (1, 'NFC、闪充停服', '通卡停电', '通卡', '通卡利用预备电供机房使用', '2019-11-27 16:22:43', '2019-11-28 04:00:00', '补登', '2019-11-27 16:23:29', '2019-12-02 17:36:55'),(2, '市民通充值异常', 'nfc-sdk Oracle数据库空间不足', '邓宜兵', '扩展Oracle表空间30G到50G', '2019-12-03 20:47:00', '2019-12-03 21:07:00', 'nfc-sdk', '2019-12-04 13:56:24', '2019-12-04 13:56:24'),(3, '市民通充值超时', 'nfc-sdk到通卡系统网络超时', '通卡', '通卡网络自行恢复', '2019-12-04 12:04:00', '2019-12-04 12:40:00', 'nfc-sdk', '2019-12-04 13:58:35', '2019-12-04 13:58:35'),(4, '市民通商户版充值提示超时', '调用通卡收单超时。内网：http://192.168.10.95:21119/onlinews/services/SupportService；外网：http://219.153.11.10:21119/onlinews/services/SupportService?wsdl', '叶兆柏', '通卡解决恢复', '2020-01-09 08:30:00', '2020-01-09 09:41:17', '所有', '2020-01-09 09:46:24', '2020-01-09 10:13:56'),(5, '市民通商户版充值提示超时', '调用收单超时', '通卡', '通卡“加密机在调整白名单”，调整完成后自行恢复，事前并未收到通卡通知', '2020-01-14 09:52:00', '2020-01-14 22:12:26', '同收单系统相关系统', '2020-01-14 22:13:52', '2020-01-14 22:13:52');
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `jlcon_myproject`.`project` WRITE;
DELETE FROM `jlcon_myproject`.`project`;
INSERT INTO `jlcon_myproject`.`project` (`id`,`name`,`owner_type`,`start_time`,`is_enable`,`create_time`,`update_time`) VALUES (1, '重庆市民通APP', 'cmf', '2016-10-01 00:00:00', 1, '2019-11-19 14:27:27', '2019-11-21 13:59:42'),(2, '通卡补登系统', 'cqt', '2017-11-01 00:00:00', 1, '2019-11-19 14:28:02', '2019-11-19 14:28:02'),(3, '通卡发票系统', 'cqt', '2017-11-01 00:00:00', 1, '2019-11-19 14:28:44', '2019-11-19 20:45:47'),(4, '手机交通卡', 'cqt', '2019-11-11 00:00:00', 1, '2019-11-19 16:01:45', '2019-11-21 13:47:37'),(5, '通卡IC卡线上服务平台', 'cqt', '2019-10-14 00:00:00', 1, '2019-11-19 20:49:09', '2019-12-09 14:03:34'),(6, 'SDK能力外放', 'cmf', '2017-01-01 00:00:00', 1, '2019-11-19 20:56:43', '2019-12-26 16:23:38'),(7, '系统运维工作', 'cqt', NULL, 1, '2019-11-20 15:40:49', '2019-11-20 15:40:49'),(8, '乘车码', 'cqt', '2019-11-01 00:00:00', 1, '2019-11-21 13:46:25', '2019-11-21 13:46:25'),(9, 'HCE', 'cqt', '2019-11-01 00:00:00', 1, '2019-11-21 13:46:52', '2019-11-21 13:46:52'),(10, '重庆市民通BOSS', 'cmf', NULL, 1, '2019-11-21 14:00:16', '2019-11-21 14:00:16'),(11, '电商', 'cmf', '2018-11-01 00:00:00', 1, '2019-11-22 09:29:42', '2019-11-22 09:29:42'),(12, 'TSP二维码', 'cmf', '2019-12-10 22:51:34', 1, '2019-12-10 22:51:39', '2019-12-10 22:51:50'),(13, '通卡公众号/官网', 'cqt', NULL, 1, '2019-12-12 17:26:13', '2019-12-12 17:26:13');
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `jlcon_myproject`.`sys_menu` WRITE;
DELETE FROM `jlcon_myproject`.`sys_menu`;
INSERT INTO `jlcon_myproject`.`sys_menu` (`menu_id`,`parent_id`,`menu_name`,`menu_icon`,`menu_url`,`leaf`,`sort`,`create_time`,`update_time`) VALUES (1, 0, '系统设置', 'layui-icon-set', '', 'NO', 1, '2019-11-19 00:00:00', '2019-11-19 00:00:00'),(2, 1, '系统参数', 'layui-icon-app', '/boss/sys_param/to_page', 'NO', NULL, '2019-11-19 00:00:00', '2019-11-19 00:00:00'),(5, 1, '菜单管理', '', '/boss/system-menu-page', 'YES', 11, '2019-11-19 00:00:00', '2019-11-19 00:00:00'),(6, 0, '用户设置', 'layui-icon-user', '', 'NO', 2, '2019-11-19 00:00:00', '2019-11-19 00:00:00'),(7, 6, '用户管理', 'layui-icon-app', '/boss/boss_user/to_page', 'NO', 21, '2019-11-19 00:00:00', '2019-11-19 00:00:00'),(8, 6, '资源管理', 'layui-icon-app', '/boss/sys_resource/to_page', 'NO', 22, '2019-11-19 00:00:00', '2019-11-19 00:00:00'),(9, 6, '角色权限管理', 'layui-icon-app', '/boss/sys_role/to_page', 'NO', NULL, '2019-11-19 00:00:00', '2019-11-19 00:00:00'),(10, 0, '文档中心', 'layui-icon-read', '', 'NO', 3, '2019-11-19 00:00:00', '2019-12-11 19:26:03'),(14, 0, '项目管理', 'layui-icon-chart-screen', '', 'NO', NULL, '2019-11-19 14:23:10', '2019-11-19 15:23:04'),(15, 14, '我的项目', 'layui-icon-app', '/boss/project/to_page', 'NO', 144, '2019-11-19 14:26:03', '2019-12-06 15:22:11'),(16, 14, '任务视图', 'layui-icon-app', '/boss/task/to_page', 'NO', 141, '2019-11-19 14:30:54', '2019-12-06 15:21:54'),(17, 14, '员工管理', 'layui-icon-app', '/boss/user/to_page', 'NO', 145, '2019-11-19 14:31:44', '2019-12-06 15:22:13'),(18, 0, '团队事务', 'layui-icon-username', '', 'NO', NULL, '2019-11-19 14:40:28', '2019-11-19 15:23:44'),(20, 0, '风险管理', 'layui-icon-auz', '', 'NO', NULL, '2019-11-19 15:16:50', '2019-11-19 15:24:01'),(21, 20, '故障记录', 'layui-icon-app', '/boss/problem_online/to_page', 'NO', NULL, '2019-11-19 15:18:09', '2019-11-19 15:18:09'),(22, 18, '请假管理', 'layui-icon-app', '/boss/team_leave/to_page', 'NO', NULL, '2019-11-19 15:48:24', '2019-11-19 15:48:24'),(24, 1, '快捷管理', 'layui-icon-app', '/boss/sys_short_cut/to_page', 'NO', NULL, '2019-11-25 15:56:14', '2019-11-25 15:56:26'),(25, 14, '我的周报', 'layui-icon-app', '/user/task/task_topage', 'NO', 143, '2019-11-27 10:55:09', '2019-12-06 15:22:09'),(26, 14, '周报视图', 'layui-icon-app', '/boss/task/to_weekly_page', 'NO', 142, '2019-11-29 10:35:38', '2019-12-06 15:22:03'),(27, 10, '前端文档/工具', 'layui-icon-app', '', 'NO', NULL, '2019-12-11 19:26:16', '2019-12-11 19:39:38'),(28, 27, 'LayUI - 官方文档', 'layui-icon-app', 'http://www.layui.com/doc/', 'NO', NULL, '2019-12-11 19:26:29', '2019-12-11 19:26:36'),(29, 27, '表单设计器', 'layui-icon-app', 'http://lowcode.magicalcoder.com/layui', 'NO', NULL, '2019-12-11 19:27:13', '2019-12-11 19:27:22'),(30, 27, 'JQuery', 'layui-icon-app', 'http://www.w3school.com.cn/jquery/jquery_ref_selectors.asp', 'NO', NULL, '2019-12-11 19:27:26', '2019-12-11 19:27:33');
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `jlcon_myproject`.`sys_param` WRITE;
DELETE FROM `jlcon_myproject`.`sys_param`;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `jlcon_myproject`.`sys_resource` WRITE;
DELETE FROM `jlcon_myproject`.`sys_resource`;
INSERT INTO `jlcon_myproject`.`sys_resource` (`id`,`parent_resource_id`,`name`,`type`,`permission`,`url`,`spread`,`create_time`,`update_time`) VALUES (1, 0, '权限管理', 'operation', '', '', 1, '2019-11-19 00:00:00', '2019-11-19 00:00:00'),(2, 1, '系统设置', 'operation', '', '', 1, '2019-11-19 00:00:00', '2019-12-11 19:52:42'),(4, 1, '用户设置', 'operation', '', '', 1, '2019-11-19 00:00:00', '2019-12-11 19:30:21'),(5, 4, '资源管理', 'operation', '', '', 1, '2019-11-19 00:00:00', '2019-11-19 00:00:00'),(6, 4, '用户管理', 'operation', '', '', 1, '2019-11-19 00:00:00', '2019-11-20 17:41:48'),(7, 4, '角色权限管理', 'operation', '', '', 1, '2019-11-19 00:00:00', '2019-11-20 17:41:49'),(9, 2, '菜单管理', 'operation', '', '', 1, '2019-11-19 00:00:00', '2019-12-08 22:26:21'),(10, 9, '列表页', 'url', 'menu_topage', '/boss/system-menu-page', 0, '2019-11-19 00:00:00', '2019-11-19 00:00:00'),(11, 5, '列表页', 'url', 'resource_topage', '/boss/sys_resource/to_page', 0, '2019-11-19 00:00:00', '2019-11-19 00:00:00'),(12, 6, '列表页', 'url', 'user_topage', '/boss/boss_user/to_page', 0, '2019-11-19 00:00:00', '2019-11-19 00:00:00'),(13, 7, '列表页', 'url', 'role_topage', '/boss/sys_role/to_page', 0, '2019-11-19 00:00:00', '2019-11-19 00:00:00'),(14, 6, '新增操作', 'operation', 'user_add_opt', '', 0, '2019-11-19 00:00:00', '2019-11-19 00:00:00'),(15, 6, '删除操作', 'operation', 'user_delete_opt', '', 0, '2019-11-19 00:00:00', '2019-11-19 00:00:00'),(16, 6, '编辑操作', 'operation', 'user_edit_opt', '', 0, '2019-11-19 00:00:00', '2019-11-19 00:00:00'),(17, 2, '系统参数', 'operation', NULL, NULL, 1, '2019-11-19 00:00:00', '2019-12-08 22:23:29'),(18, 17, '列表页', 'url', 'sysParam_topage', '/boss/sys_param/to_page', 1, '2019-11-19 00:00:00', '2019-11-19 00:00:00'),(19, 17, '新增操作', 'operation', 'sysParam_add_opt', NULL, 1, '2019-11-19 00:00:00', '2019-11-19 00:00:00'),(20, 17, '删除操作', 'operation', 'sysParam_delete_opt', NULL, 1, '2019-11-19 00:00:00', '2019-11-19 00:00:00'),(21, 17, '编辑操作', 'operation', 'sysParam_edit_opt', NULL, 1, '2019-11-19 00:00:00', '2019-11-19 00:00:00'),(22, 1, '项目管理', 'operation', '', '', 1, '2019-11-19 14:23:56', '2019-12-11 19:31:51'),(23, 22, '我的项目', 'operation', NULL, NULL, 0, '2019-11-19 14:26:03', '2019-12-16 22:37:36'),(24, 23, '列表页', 'url', 'project_topage', '/boss/project/to_page', 1, '2019-11-19 14:26:03', '2019-11-19 14:26:03'),(25, 23, '新增操作', 'operation', 'project_add_opt', NULL, 1, '2019-11-19 14:26:03', '2019-11-19 14:26:03'),(26, 23, '删除操作', 'operation', 'project_delete_opt', NULL, 1, '2019-11-19 14:26:03', '2019-11-19 14:26:03'),(27, 23, '编辑操作', 'operation', 'project_edit_opt', NULL, 1, '2019-11-19 14:26:03', '2019-11-19 14:26:03'),(28, 22, '任务管理', 'operation', NULL, NULL, 0, '2019-11-19 14:30:54', '2019-12-11 19:31:55'),(29, 28, '列表页', 'url', 'task_topage', '/boss/task/to_page', 1, '2019-11-19 14:30:54', '2019-11-19 14:30:54'),(30, 28, '新增操作', 'operation', 'task_add_opt', NULL, 1, '2019-11-19 14:30:54', '2019-11-19 14:30:54'),(31, 28, '删除操作', 'operation', 'task_delete_opt', NULL, 1, '2019-11-19 14:30:54', '2019-11-19 14:30:54'),(32, 28, '编辑操作', 'operation', 'task_edit_opt', NULL, 1, '2019-11-19 14:30:54', '2019-11-19 14:30:54'),(43, 1, '团队事务', 'operation', '', '', 1, '2019-11-19 14:41:18', '2019-12-08 22:24:00'),(49, 22, '员工管理', 'operation', NULL, NULL, 0, '2019-11-19 14:59:30', '2019-12-11 19:31:55'),(50, 49, '列表页', 'url', 'user_topage', '/boss/user/to_page', 1, '2019-11-19 14:59:30', '2019-11-19 14:59:30'),(51, 49, '新增操作', 'operation', 'user_add_opt', NULL, 1, '2019-11-19 14:59:30', '2019-11-19 14:59:30'),(52, 49, '删除操作', 'operation', 'user_delete_opt', NULL, 1, '2019-11-19 14:59:30', '2019-11-19 14:59:30'),(53, 49, '编辑操作', 'operation', 'user_edit_opt', NULL, 1, '2019-11-19 14:59:30', '2019-11-19 14:59:30'),(54, 1, '风险管理', 'operation', '', '', 0, '2019-11-19 15:17:16', '2019-12-11 19:29:52'),(57, 54, '故障记录', 'operation', NULL, NULL, 1, '2019-11-19 15:20:09', '2019-11-19 15:20:09'),(58, 57, '列表页', 'url', 'problemOnline_topage', '/boss/problem_online/to_page', 1, '2019-11-19 15:20:09', '2019-11-19 15:20:09'),(59, 57, '新增操作', 'operation', 'problemOnline_add_opt', NULL, 1, '2019-11-19 15:20:09', '2019-11-19 15:20:09'),(60, 57, '删除操作', 'operation', 'problemOnline_delete_opt', NULL, 1, '2019-11-19 15:20:09', '2019-11-19 15:20:09'),(61, 57, '编辑操作', 'operation', 'problemOnline_edit_opt', NULL, 1, '2019-11-19 15:20:09', '2019-11-19 15:20:09'),(62, 43, '请假管理', 'operation', NULL, NULL, 1, '2019-11-19 15:48:24', '2019-12-08 22:24:21'),(63, 62, '列表页', 'url', 'teamLeave_topage', '/boss/team_leave/to_page', 1, '2019-11-19 15:48:24', '2019-11-19 15:48:24'),(64, 62, '新增操作', 'operation', 'teamLeave_add_opt', NULL, 1, '2019-11-19 15:48:24', '2019-11-19 15:48:24'),(65, 62, '删除操作', 'operation', 'teamLeave_delete_opt', NULL, 1, '2019-11-19 15:48:24', '2019-11-19 15:48:24'),(66, 62, '编辑操作', 'operation', 'teamLeave_edit_opt', NULL, 1, '2019-11-19 15:48:24', '2019-11-19 15:48:24'),(67, 1, '参考资料', 'operation', '', '', 1, '2019-11-22 14:56:50', '2019-12-08 22:30:25'),(68, 67, 'LayUI文档', 'url', 'layui', 'http://www.layui.com/doc/', 0, '2019-11-22 14:57:17', '2019-12-08 22:34:47'),(69, 67, 'Magicalcoder', 'url', 'magicalcoder', 'http://lowcode.magicalcoder.com/layui', 0, '2019-11-22 14:58:51', '2019-12-08 22:34:57'),(70, 67, 'JQuery', 'url', 'JQuery', 'http://www.w3school.com.cn/jquery/jquery_ref_selectors.asp', 0, '2019-11-22 14:59:21', '2019-12-08 22:35:02'),(76, 2, '快捷管理', 'operation', NULL, NULL, 0, '2019-11-25 14:43:38', '2019-12-11 19:52:48'),(77, 76, '列表页', 'url', 'sysShortCut_topage', '/boss/sys_short_cut/to_page', 1, '2019-11-25 14:43:38', '2019-11-25 14:43:38'),(78, 76, '新增操作', 'operation', 'sysShortCut_add_opt', NULL, 1, '2019-11-25 14:43:38', '2019-11-25 14:43:38'),(79, 76, '删除操作', 'operation', 'sysShortCut_delete_opt', NULL, 1, '2019-11-25 14:43:38', '2019-11-25 14:43:38'),(80, 76, '编辑操作', 'operation', 'sysShortCut_edit_opt', NULL, 1, '2019-11-25 14:43:38', '2019-11-25 14:43:38'),(81, 22, '我的周报', 'operation', '', '', 1, '2019-11-27 10:55:58', '2019-11-27 10:56:19'),(82, 81, '列表页', 'url', 'task_topage', '/user/task/task_topage', 0, '2019-11-27 10:56:18', '2019-11-29 16:02:47'),(83, 22, '周报视图', 'operation', '', '', 1, '2019-11-29 10:37:47', '2019-11-29 10:38:09'),(84, 83, '列表页', 'url', 'to_weekly_page', '/boss/task/to_weekly_page', 0, '2019-11-29 10:38:08', '2019-12-04 14:54:50');
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `jlcon_myproject`.`sys_role` WRITE;
DELETE FROM `jlcon_myproject`.`sys_role`;
INSERT INTO `jlcon_myproject`.`sys_role` (`id`,`role_name`,`role_code`,`create_time`,`update_time`) VALUES (1, '超级管理员', 'system_super_admin', '2019-11-19 00:00:00', '2019-12-05 14:37:54'),(2, '操作员', 'operator', '2019-11-20 17:54:03', '2019-11-20 17:54:03'),(3, '项目查询者', 'system_viewer', '2019-11-21 17:26:57', '2019-12-05 14:38:19'),(4, '考勤查询者', 'system_kaoqin', '2019-11-21 17:28:21', '2019-12-05 14:38:05'),(5, '技术部', 'system_tech', '2019-11-29 10:40:05', '2019-12-05 14:37:39');
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `jlcon_myproject`.`sys_role_resource` WRITE;
DELETE FROM `jlcon_myproject`.`sys_role_resource`;
INSERT INTO `jlcon_myproject`.`sys_role_resource` (`id`,`role_id`,`resource_id`,`create_time`,`update_time`) VALUES (64, 4, 63, '2019-11-21 17:28:29', '2019-11-21 17:28:29'),(331, 3, 29, '2019-12-04 16:04:03', '2019-12-04 16:04:03'),(332, 3, 84, '2019-12-04 16:04:03', '2019-12-04 16:04:03'),(554, 2, 18, '2019-12-08 22:38:35', '2019-12-08 22:38:35'),(555, 2, 77, '2019-12-08 22:38:35', '2019-12-08 22:38:35'),(556, 2, 11, '2019-12-08 22:38:35', '2019-12-08 22:38:35'),(557, 2, 12, '2019-12-08 22:38:35', '2019-12-08 22:38:35'),(558, 2, 13, '2019-12-08 22:38:35', '2019-12-08 22:38:35'),(559, 2, 24, '2019-12-08 22:38:36', '2019-12-08 22:38:36'),(560, 2, 29, '2019-12-08 22:38:36', '2019-12-08 22:38:36'),(561, 2, 50, '2019-12-08 22:38:36', '2019-12-08 22:38:36'),(562, 2, 84, '2019-12-08 22:38:36', '2019-12-08 22:38:36'),(563, 2, 63, '2019-12-08 22:38:36', '2019-12-08 22:38:36'),(564, 2, 58, '2019-12-08 22:38:36', '2019-12-08 22:38:36'),(565, 2, 68, '2019-12-08 22:38:36', '2019-12-08 22:38:36'),(566, 2, 69, '2019-12-08 22:38:36', '2019-12-08 22:38:36'),(567, 2, 70, '2019-12-08 22:38:36', '2019-12-08 22:38:36'),(730, 1, 10, '2019-12-11 19:32:26', '2019-12-11 19:32:26'),(731, 1, 18, '2019-12-11 19:32:26', '2019-12-11 19:32:26'),(732, 1, 19, '2019-12-11 19:32:27', '2019-12-11 19:32:27'),(733, 1, 20, '2019-12-11 19:32:27', '2019-12-11 19:32:27'),(734, 1, 21, '2019-12-11 19:32:27', '2019-12-11 19:32:27'),(735, 1, 77, '2019-12-11 19:32:27', '2019-12-11 19:32:27'),(736, 1, 78, '2019-12-11 19:32:27', '2019-12-11 19:32:27'),(737, 1, 79, '2019-12-11 19:32:27', '2019-12-11 19:32:27'),(738, 1, 80, '2019-12-11 19:32:27', '2019-12-11 19:32:27'),(739, 1, 11, '2019-12-11 19:32:27', '2019-12-11 19:32:27'),(740, 1, 12, '2019-12-11 19:32:27', '2019-12-11 19:32:27'),(741, 1, 14, '2019-12-11 19:32:27', '2019-12-11 19:32:27'),(742, 1, 15, '2019-12-11 19:32:27', '2019-12-11 19:32:27'),(743, 1, 16, '2019-12-11 19:32:27', '2019-12-11 19:32:27'),(744, 1, 13, '2019-12-11 19:32:27', '2019-12-11 19:32:27'),(745, 1, 24, '2019-12-11 19:32:27', '2019-12-11 19:32:27'),(746, 1, 25, '2019-12-11 19:32:27', '2019-12-11 19:32:27'),(747, 1, 26, '2019-12-11 19:32:27', '2019-12-11 19:32:27'),(748, 1, 27, '2019-12-11 19:32:27', '2019-12-11 19:32:27'),(749, 1, 29, '2019-12-11 19:32:28', '2019-12-11 19:32:28'),(750, 1, 30, '2019-12-11 19:32:28', '2019-12-11 19:32:28'),(751, 1, 31, '2019-12-11 19:32:28', '2019-12-11 19:32:28'),(752, 1, 32, '2019-12-11 19:32:28', '2019-12-11 19:32:28'),(753, 1, 50, '2019-12-11 19:32:28', '2019-12-11 19:32:28'),(754, 1, 51, '2019-12-11 19:32:28', '2019-12-11 19:32:28'),(755, 1, 52, '2019-12-11 19:32:28', '2019-12-11 19:32:28'),(756, 1, 53, '2019-12-11 19:32:28', '2019-12-11 19:32:28'),(757, 1, 84, '2019-12-11 19:32:28', '2019-12-11 19:32:28'),(758, 1, 63, '2019-12-11 19:32:28', '2019-12-11 19:32:28'),(759, 1, 64, '2019-12-11 19:32:28', '2019-12-11 19:32:28'),(760, 1, 65, '2019-12-11 19:32:28', '2019-12-11 19:32:28'),(761, 1, 66, '2019-12-11 19:32:28', '2019-12-11 19:32:28'),(762, 1, 58, '2019-12-11 19:32:28', '2019-12-11 19:32:28'),(763, 1, 59, '2019-12-11 19:32:28', '2019-12-11 19:32:28'),(764, 1, 60, '2019-12-11 19:32:28', '2019-12-11 19:32:28'),(765, 1, 61, '2019-12-11 19:32:28', '2019-12-11 19:32:28'),(766, 1, 68, '2019-12-11 19:32:28', '2019-12-11 19:32:28'),(767, 1, 69, '2019-12-11 19:32:28', '2019-12-11 19:32:28'),(768, 1, 70, '2019-12-11 19:32:29', '2019-12-11 19:32:29'),(776, 5, 30, '2019-12-11 19:41:35', '2019-12-11 19:41:35'),(777, 5, 31, '2019-12-11 19:41:35', '2019-12-11 19:41:35'),(778, 5, 32, '2019-12-11 19:41:35', '2019-12-11 19:41:35'),(779, 5, 82, '2019-12-11 19:41:35', '2019-12-11 19:41:35');
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `jlcon_myproject`.`sys_short_cut` WRITE;
DELETE FROM `jlcon_myproject`.`sys_short_cut`;
INSERT INTO `jlcon_myproject`.`sys_short_cut` (`short_cut_id`,`name`,`url`,`enable`,`role_code`,`owner_type`,`open_type`,`ower_id`,`icon`,`sort`,`create_time`,`update_time`) VALUES (1, '百度', 'https://www.baidu.com', 1, 'outer_baidu', 'system', 'linker', NULL, 'layui-icon-app', NULL, '2021-01-12 14:04:07', '2021-01-12 14:04:07');
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `jlcon_myproject`.`task` WRITE;
DELETE FROM `jlcon_myproject`.`task`;
INSERT INTO `jlcon_myproject`.`task` (`id`,`project_id`,`name`,`coder`,`user_id`,`code_start`,`code_end`,`time_cost`,`progress`,`status`,`pending_reson`,`remark_task`,`create_time`,`update_time`) VALUES (1, 4, '小米手机删卡', '何奎', 5, '2019-11-19 06:00:00', NULL, 40.00, 50, 'pending', '等待小米和雪球联调完开卡', '等待小米和雪球联调完开卡', NULL, NULL),(2, 5, '老年卡年审对接（Android）', '王映刚', 6, '2019-10-14 00:00:00', '2019-12-03 15:16:21', 296.00, 100, 'finish', '', '已上线', NULL, '2019-12-06 14:57:00'),(3, 5, '老年卡年审对接（IOS）', '郭威', 7, '2019-10-14 00:00:00', '2019-12-03 15:17:56', 296.00, 100, 'finish', '', '已上线', NULL, NULL),(4, 6, '农行SDK v2.0（Android）', '王映刚', 6, '2019-07-01 00:00:00', NULL, 55.00, 90, 'run', '', '已提供了集成支付的sdk', NULL, '2020-01-10 16:57:37'),(5, 6, '建行SDK v2.0（IOS）', '郭威', 7, '2019-06-01 00:00:00', NULL, 240.00, 90, 'run', '', '12月内上线', NULL, NULL),(6, 6, '建行SDK v2.0（Android）', '王映刚', 6, '2019-06-01 00:00:00', '2019-12-20 00:00:00', 250.00, 100, 'finish', '', '12月内上线\n1.已调教新包到建行\n2.优化图片大小\n3.兼容Android Q\n4.使用压缩版本的SO文件后打包', NULL, '2019-12-21 12:42:50'),(9, 1, '大数据平台统计优化', '汤宗卫', 1, '2019-10-01 00:00:00', '2019-11-20 00:00:00', NULL, 100, 'finish', '', '使用mysql方式替换hbase', NULL, NULL),(10, 4, '手机交通卡对接发票系统', '周磊', 2, NULL, NULL, NULL, 0, 'plan', '', '暂未接到对接通知', NULL, NULL),(11, 10, '业务开启 / 关闭管理', '唐婷婷', 4, '2019-11-04 00:00:00', '2019-11-15 00:00:00', 80.00, 100, 'finish', '', '11月20日，已上线', NULL, NULL),(12, 10, '交通卡充值预警', '唐婷婷', 4, '2019-11-04 00:00:00', '2019-11-15 00:00:00', 80.00, 100, 'finish', '', '11月20日，已上线', NULL, NULL),(13, 10, '网点管理导出添加地址信息', '唐婷婷', 4, '2019-11-04 00:00:00', '2019-11-15 00:00:00', 80.00, 100, 'finish', '', '11月20日，已上线', NULL, NULL),(14, 10, '商户版开关优化，添加日期范围自动关闭和描述', '唐婷婷', 4, '2019-11-04 00:00:00', '2019-11-15 00:00:00', 80.00, 100, 'finish', '', '11月20日，已上线', NULL, NULL),(15, 10, 'BOSS首页交通卡充值时辰变化图', '陈方华', 3, '2019-11-04 00:00:00', '2019-11-15 00:00:00', 80.00, 100, 'finish', '', '11月20日，已上线', NULL, NULL),(16, 10, '用户解锁', '陈方华', 3, '2019-11-04 00:00:00', '2019-11-15 00:00:00', 80.00, 100, 'finish', '', '11月20日，已上线', NULL, NULL),(17, 10, '支付成功交易数据明细', '汤宗卫', 1, '2019-11-04 00:00:00', '2019-11-15 00:00:00', 40.00, 100, 'finish', '', '11月20日，已上线', NULL, NULL),(18, 10, '统计系统用户活跃度优化', '汤宗卫', 1, '2019-11-04 00:00:00', '2019-11-15 00:00:00', 80.00, 100, 'finish', '', '11月20日，已上线', NULL, NULL),(19, 2, '闪充商户版写卡数量接口（预警用）', '周磊', 2, '2019-11-04 00:00:00', '2019-11-15 00:00:00', 24.00, 100, 'finish', '', '11月20日，已上线', NULL, '2019-12-08 22:03:51'),(20, 6, '农行SDK v2.0（IOS）', '郭威', 7, '2019-07-01 00:00:00', NULL, NULL, 80, 'run', '', '已提供新包，解决支付问题', NULL, NULL),(21, 4, '一加、realm删卡', '王映刚', 6, '2019-11-04 00:00:00', '2019-11-20 00:00:00', 40.00, 100, 'finish', '', '11月20日，已上线', NULL, NULL),(22, 8, '乘车码测试', '任如娟', 9, '2019-11-25 00:00:00', '2019-12-17 18:00:00', 10.00, 100, 'finish', '', '已测完，新用户开通、刷卡、补足开卡费均正常', NULL, '2019-12-20 17:06:45'),(23, 9, 'HCE保密协议', '江路', 13, '2019-11-18 00:00:00', '2019-12-17 00:00:00', 4.00, 100, 'finish', '', '1、保密协议乙方由中电更改为重庆移动金融\n2、已经走完流程', NULL, '2019-12-19 09:22:07'),(26, 9, '提供测试卡给（何长生）', '江路', 13, '2019-11-15 00:00:00', '2019-11-15 00:00:00', 0.50, 100, 'finish', '', '', NULL, '2019-12-11 11:15:18'),(27, 1, '集成百度统计（IOS）', '郭威', 7, '2019-11-25 13:35:46', '2019-12-03 15:31:29', 3.00, 100, 'finish', '', '已上线', NULL, NULL),(28, 6, '农行优惠支付', '汤宗卫', 1, '2019-11-25 09:00:00', NULL, 4.00, 40, 'run', '', '', NULL, '2019-12-06 14:08:45'),(29, 5, '学生卡月票（Android）', '王映刚', 6, '2019-11-29 10:31:55', NULL, 145.00, 91, 'run', '', '1.搭建界面\n2.集成基本逻辑\n3.讨论需求，确认细节需求相关\n4.完成通知后台与充值相关逻辑\n5.完善流程上的漏洞，以及修改一些已发现的bug，修正sdk修改后的影响\n6.集成新的sdk\n7.修改已提出的bug\n8.讨论了目前冲正出现的问题，可能会涉及我们流程会有改动', NULL, '2020-01-10 16:58:07'),(30, 5, '学生卡月票（IOS）', '郭威', 7, '2019-11-29 10:32:17', NULL, 96.00, 85, 'run', '', '', NULL, '2020-01-10 17:00:56'),(35, 5, '学生卡创单', '汤宗卫', 1, '2019-12-02 09:00:00', '2019-12-04 18:00:00', 4.00, 100, 'finish', '', '', NULL, '2019-12-06 14:06:29'),(36, 4, '魅族删卡', '王映刚', 6, '2019-08-09 00:00:00', '2019-12-19 00:00:00', 50.00, 100, 'finish', '', '重新开始对接', NULL, '2019-12-21 12:43:16'),(37, 1, '广告拨打电话BUG（IOS）', '郭威', 7, '2019-11-25 00:00:00', '2019-12-03 15:31:06', 3.00, 100, 'finish', '', '已上线', NULL, NULL),(38, 5, '查询代写卡列表', '汤宗卫', 1, '2019-12-02 09:00:00', '2019-12-05 18:00:00', 3.00, 100, 'finish', '', '', NULL, '2019-12-06 14:06:36'),(39, 5, '学生卡写卡通知', '汤宗卫', 1, '2019-12-02 00:00:00', '2019-12-04 18:00:00', 2.00, 100, 'finish', '', '', NULL, '2019-12-06 14:07:03'),(40, 5, '学生卡变更起止月份', '汤宗卫', 1, '2019-12-02 00:00:00', '2019-12-05 18:00:00', 5.00, 100, 'finish', '', '', NULL, '2019-12-06 14:06:44'),(41, 5, '交易记录', '汤宗卫', 1, '2019-12-02 00:00:00', '2019-12-12 18:00:00', 5.00, 100, 'finish', '', '', NULL, '2019-12-13 14:15:31'),(42, 5, '交易进度', '汤宗卫', 1, '2019-12-02 00:00:00', '2019-12-11 18:00:00', 5.00, 100, 'finish', '', '', NULL, '2019-12-13 14:14:59'),(43, 5, '学生卡月票冲次交易记录', '汤宗卫', 1, '2019-12-02 00:00:00', '2019-12-11 18:00:00', 5.00, 100, 'finish', '', '', NULL, '2019-12-13 14:14:06'),(44, 5, '公交充值交易明细统计', '汤宗卫', 1, '2019-12-02 00:00:00', '2019-12-10 18:00:00', 5.00, 100, 'finish', '', '', NULL, '2019-12-13 14:13:28'),(45, 5, '学生卡对账', '汤宗卫', 1, '2019-12-02 00:00:00', NULL, 2.00, 50, 'run', '', '', NULL, '2019-12-20 14:46:08'),(46, 5, '学生卡差错账', '汤宗卫', 1, '2019-12-02 00:00:00', NULL, 2.00, 40, 'run', '', '', NULL, '2019-12-20 14:46:02'),(47, 5, '支付成功交易记录明细', '汤宗卫', 1, '2019-12-02 00:00:00', '2019-12-09 18:00:00', 5.00, 100, 'finish', '', '', NULL, '2019-12-13 14:12:04'),(48, 5, '公交卡充值退款', '汤宗卫', 1, '2019-12-02 00:00:00', NULL, 5.00, 80, 'run', '调用IC卡平台冲正接口异常。现正在和对方讨论优化方案。', '', NULL, '2020-01-10 12:52:12'),(49, 5, '公交卡写卡异常状态变更', '汤宗卫', 1, '2019-12-02 00:00:00', NULL, 3.00, 80, 'run', '调用IC卡平台冲正接口异常。现正在和对方讨论优化方案。', '', NULL, '2020-01-10 12:52:17'),(51, 10, '支付渠道统计报表测试用例编写', '任如娟', 9, '2019-12-04 00:00:00', NULL, 15.00, 40, 'run', '', '增加农业银行和学生卡充次的数据，和对应查询条件', NULL, '2019-12-12 18:04:38'),(52, 5, '学生卡功能部分用例编写', '郑雪娅', 11, '2019-12-02 00:00:00', '2019-12-12 00:00:00', 48.00, 100, 'finish', '', '新增需求用例已补齐\n增加额度扣完同步traffic关闭业务开关并预警功能用例', NULL, '2019-12-12 17:25:49'),(53, 4, '魅族删卡测试上线', '郑雪娅', 11, '2019-12-02 00:00:00', '2019-12-26 00:00:00', 25.00, 100, 'finish', '魅族功能已验证完毕，等待老年卡年检记录测试完成一起上线', '', NULL, '2019-12-25 10:46:22'),(55, 5, '老年卡年检记录(APP)', '陈方华', 3, '2019-12-02 00:00:00', '2019-12-20 00:00:00', 40.00, 100, 'finish', '', '', NULL, '2019-12-20 17:19:28'),(56, 5, '老年卡年检记录(BOSS)', '陈方华', 3, '2019-12-02 00:00:00', '2019-12-20 00:00:00', 40.00, 100, 'finish', '', '', NULL, '2019-12-20 17:19:56'),(57, 7, '生产环境网络设备及服务检查日常检查', '李鹏', 12, '2020-01-06 00:00:00', '2020-01-10 00:00:00', 1.00, 100, 'finish', '', '', NULL, '2020-01-10 18:26:59'),(58, 7, '验证数据库迁移事务', '李鹏', 12, '2020-01-06 00:00:00', '2020-01-10 00:00:00', 24.00, 100, 'finish', '', '', NULL, '2020-01-10 18:27:30'),(59, 10, '公安局检测', '唐婷婷', 4, '2019-11-25 00:00:00', '2019-12-18 14:32:12', 40.00, 100, 'finish', '', '配合检测做对应调整；调整过的，均已上线', NULL, '2019-12-18 14:32:15'),(60, 7, '配合各部门订正线上数据库数据', '李鹏', 12, '2020-01-06 00:00:00', '2020-01-10 00:00:00', 1.00, 100, 'finish', '', '', NULL, '2020-01-10 18:27:14'),(64, 7, 'FTP日志服务检查日志备份完成情况', '李鹏', 12, '2020-01-06 00:00:00', '2020-01-10 00:00:00', 0.30, 100, 'finish', '', '', NULL, '2020-01-10 18:27:47'),(65, 10, 'traffic和bigdata部分公交订单支付状态不一致', '汤宗卫', 1, '2019-12-06 10:00:00', '2019-12-06 12:00:00', 2.00, 100, 'finish', '', '', '2019-12-06 13:54:28', '2019-12-06 13:54:28'),(66, 10, '优化公交卡充值明细统计定时任务，解决schedule项目内存溢出', '汤宗卫', 1, '2019-12-01 09:00:00', '2019-12-03 11:00:00', 18.00, 100, 'finish', '', '12月3日，已上线', NULL, '2019-12-06 14:08:06'),(67, 10, '应运营要求：无法原路退款订单，财务线下手动退款，处理订单状态', '汤宗卫', 1, '2019-12-05 15:00:00', '2019-12-05 15:30:00', 0.50, 100, 'finish', '', '', NULL, '2019-12-06 14:07:31'),(68, 5, '敬老卡年审上线测试', '任如娟', 9, '2019-12-02 13:30:00', '2019-12-03 14:00:00', 8.00, 100, 'finish', '', '', NULL, '2019-12-06 14:25:42'),(69, 11, '商城H5界面', '张通榆', 8, '2019-12-04 00:00:00', NULL, 24.00, 20, 'run', '', '已根据原型完成大部分H5界面框架，等UI设计出来后再进行界面美化和数据绑定', NULL, '2019-12-06 14:36:10'),(70, 5, '通卡国密升级测试环境验证', '郑雪娅', 11, '2019-12-04 00:00:00', '2019-12-06 00:00:00', 2.00, 100, 'finish', '', '', '2019-12-06 14:28:51', '2019-12-06 14:28:51'),(71, 1, '农行优惠并发脚本编写', '郑雪娅', 11, '2019-12-06 00:00:00', '2019-12-07 00:00:00', 3.00, 100, 'finish', '', '', '2019-12-06 14:29:59', '2019-12-06 14:29:59'),(72, 5, '敬老卡年审操作说明文档整理', '任如娟', 9, '2019-12-03 11:30:00', '2019-12-03 15:00:00', 3.00, 100, 'finish', '', '', '2019-12-06 14:31:44', '2019-12-06 14:31:44'),(73, 1, '魅族删卡', '何奎', 5, '2019-12-02 00:00:00', '2019-12-06 14:33:09', 40.00, 70, 'run', '', '再次提测', NULL, '2019-12-13 10:08:56'),(74, 5, '协助填写客户端软件自查表', '任如娟', 9, '2019-12-04 11:00:00', '2019-12-05 15:00:00', 4.00, 100, 'finish', '', '', NULL, '2019-12-08 22:13:02'),(75, 2, '处理在线充值平台运营订单', '周磊', 2, '2019-12-02 00:00:00', '2019-12-06 00:00:00', 8.00, 100, 'finish', '', '目前据运营反应有订单号：201911291334170365448出现通卡以及用户写卡成功，但我方写卡失败的情况，该情况与以往的充值写卡不一致，目前发现我方并无写卡指令，用户也能写卡成功，暂不清楚用户是从哪里写卡成功的。说明：后端并未下发写卡指令。201911291005491347471：此订单与上面的情况相似，不过该订单并未成功', '2019-12-06 14:45:31', '2019-12-06 14:45:31'),(76, 2, '排查近期商户版充值超时问题', '周磊', 2, '2019-12-02 00:00:00', '2019-12-06 00:00:00', 8.00, 100, 'finish', '', '', NULL, '2019-12-16 12:46:26'),(77, 1, '配合通卡收单升级国密测试', '任如娟', 9, '2019-12-04 16:30:00', '2019-12-05 17:00:00', 3.00, 100, 'finish', '', '', '2019-12-06 14:49:29', '2019-12-06 14:49:29'),(78, 10, '沟通公交卡余额变动数据更新不及时问题', '任如娟', 9, '2019-12-04 10:30:00', '2019-12-09 00:00:00', 2.00, 100, 'finish', '', '赵先发已处理，暂时数据同步正常', NULL, '2019-12-12 17:32:19'),(79, 5, 'boss v3.1.4.1上线测试', '郑雪娅', 11, '2019-12-02 00:00:00', '2019-12-02 14:00:00', 2.00, 100, 'finish', '', '', NULL, '2019-12-06 15:51:10'),(80, 5, '参与市民通BOSS需求宣讲', '王小艳', 10, '2019-12-02 00:00:00', '2019-12-02 00:00:00', 2.00, 100, 'finish', '', '学生卡相关BOSS后台业务', '2019-12-06 15:12:48', '2019-12-06 15:12:48'),(81, 5, '市民通BOSS-V3.1.4上线功能验证', '王小艳', 10, '2019-12-02 00:00:00', '2019-12-02 00:00:00', 1.00, 100, 'finish', '', '上线功能：敬老卡开关、会员管理解锁功能', '2019-12-06 15:13:56', '2019-12-06 15:13:56'),(82, 5, '测试环境NFC充值和闪充对账功能验证', '王小艳', 10, '2019-12-05 00:00:00', '2019-12-09 00:00:00', 8.00, 100, 'finish', '', '通卡收单国密升级，验证对账功能', NULL, '2019-12-13 10:45:40'),(83, 10, '公交卡充值明细统计数据异常排查', '王小艳', 10, '2019-12-06 10:00:00', '2019-12-06 13:00:00', 3.00, 100, 'finish', '', '露露反馈12月2日查询的统计数据与12月6日查询的统计数据不一致，原因为bigdata出现内存溢出经优化后，于2019-12-03上线导致，但在排查过程中发现有一部分数据状态未同步，建议后续还需对同步功能进行优化', NULL, '2019-12-06 15:21:46'),(84, 5, '市民通BOSS-v3.1.4.2测试用例', '王小艳', 10, '2019-12-02 00:00:00', '2019-12-06 00:00:00', 28.00, 100, 'finish', '', '市民通BOSSv3.1.4.2测试用例：交易记录、订单详情、学生卡充次交易记录、公交卡写卡异常状态变更、学生卡对账、学生卡对账差异', '2019-12-06 15:25:29', '2019-12-06 15:25:29'),(85, 3, '通卡电子发票服务器被意外停止', '周磊', 2, '2019-12-09 00:00:00', '2019-12-09 00:00:00', 8.00, 100, 'finish', '', '上周5出现通卡电子发票服务被意外停止，目前已恢复，根据网络提供的操作系统日志，发现该服务器有被重启的迹象，当时通卡电子发票相关的其他服务器也被重启（白望反馈的）。', '2019-12-09 10:00:44', '2019-12-09 10:00:44'),(86, 3, '通卡电子发票闪冲充值数据补全', '周磊', 2, '2019-12-09 00:00:00', '2019-12-10 00:00:00', 8.00, 100, 'finish', '', '闪冲充值交易数据受服务器停机影响，也需要对数据进行补全', '2019-12-09 11:58:05', '2019-12-09 11:58:05'),(87, 2, '闪冲充值出现网络波动', '周磊', 2, '2019-12-09 00:00:00', '2019-12-10 00:00:00', 8.00, 100, 'finish', '', '周一出现商户部分无法充值现象', '2019-12-09 13:11:52', '2019-12-09 13:11:52'),(88, 2, '蓝牙平台冲正成功，但通卡无冲正记录的情况', '周磊', 2, '2019-12-10 00:00:00', '2019-12-12 00:00:00', 40.00, 100, 'finish', '', '', NULL, '2019-12-13 13:49:04'),(89, 2, '运营数据查询', '唐婷婷', 4, '2019-12-10 00:00:00', '2019-12-11 00:00:00', 4.00, 100, 'finish', '', '查询商户及子商户下所有的网点挂靠的所有终端', NULL, '2019-12-10 17:24:57'),(90, 10, '学生卡闪充充次功能状态预警', '唐婷婷', 4, '2019-12-11 00:00:00', '2019-12-25 00:00:00', 12.00, 100, 'finish', '', 'boss添加预警人员，发送预警短信，app接口；已上线', NULL, '2019-12-27 13:28:22'),(91, 2, '商户账号问题', '唐婷婷', 4, '2019-12-12 00:00:00', '2019-12-12 00:00:00', 4.00, 100, 'finish', '', '账号存在多个，保存商户业务报错；处理了多余的数据', NULL, '2019-12-13 09:32:47'),(92, 5, '老年卡年检记录BOSS系统测试', '郑雪娅', 11, '2019-12-12 00:00:00', '2019-12-26 00:00:00', 40.00, 100, 'finish', '', '', NULL, '2019-12-25 10:47:01'),(93, 6, '建行IOS线上包测试', '郑雪娅', 11, '2019-12-11 00:00:00', '2019-12-12 00:00:00', 3.00, 100, 'finish', '', '', '2019-12-12 17:18:50', '2019-12-12 17:18:50'),(94, 13, '交易记录金额展示错误问题修正测试', '郑雪娅', 11, '2019-12-11 00:00:00', '2019-12-11 00:00:00', 2.00, 100, 'finish', '', '', NULL, '2019-12-12 17:27:29'),(95, 5, '学生卡SDK冲正流程讨论', '任如娟', 9, '2019-12-10 14:10:00', '2019-12-26 18:00:00', 8.00, 100, 'finish', '', '1.SDK冲正节点\n2.后台冲正接口提供\n3.还未确认是否提供成功通知的接口\n4.还未提供取消订单的接口', NULL, '2019-12-27 16:33:43'),(96, 5, '学生卡APP写卡逻辑讨论', '任如娟', 9, '2019-12-09 17:30:00', '2019-12-18 18:00:00', 5.00, 100, 'finish', '', '1.APP需要缓存通知状态\n2.APP写卡过程继续保存处理中状态\n4.APP去掉充值未写卡，选择月份已过期，需要修改月份的功能', NULL, '2019-12-20 17:12:23'),(97, 6, '农行优惠设置测试用例', '任如娟', 9, '2019-12-11 09:00:00', '2019-12-26 18:00:00', 13.00, 100, 'finish', '', '1.交易优惠管理测试用例\n2.交易优惠设置测试用例', NULL, '2019-12-27 16:36:09'),(98, 2, '补登商户', '任如娟', 9, '2019-12-12 10:00:00', '2019-12-12 11:50:00', 2.00, 100, 'finish', '', '1.主账号修改自己的手机号及登录名导致问题\n2.管理用户修改手机号导致主账号与子账号手机号相同', '2019-12-12 18:10:00', '2019-12-12 18:10:00'),(99, 6, '建行新版本上线前测试', '任如娟', 9, '2019-12-11 16:40:00', '2019-12-27 18:00:00', 10.00, 100, 'finish', '', '1.Android包测试\n2.上线后老版本升级提示方案讨论\n3.还未完成升级提示功能开发及测试\n4.即将上线版本测试', NULL, '2019-12-27 16:32:34'),(100, 1, '老年卡进度状态功能', '何奎', 5, '2019-12-09 00:00:00', '2019-12-13 10:04:59', 24.00, 100, 'finish', '', '已结上线', NULL, '2019-12-27 17:18:22'),(101, 1, '百度统计错误率', '何奎', 5, '2019-12-09 00:00:00', '2019-12-13 10:06:52', 24.00, 100, 'finish', '', '错误率过高，分析原因，定位出错位置，修复', NULL, '2019-12-27 17:17:42'),(102, 1, '个推失败修复', '何奎', 5, '2019-12-09 00:00:00', '2019-12-27 00:00:00', 16.00, 35, 'run', '', '查找推送失败原因', NULL, '2020-01-10 11:13:22'),(103, 5, 'Android Studio环境安装及测试', '王小艳', 10, '2019-12-09 00:00:00', '2019-12-10 00:00:00', 10.00, 100, 'finish', '', '安装Android Studio环境，测试是否能正常打印日志', NULL, '2019-12-13 14:13:22'),(104, 1, '协助补电子发票丢失数据', '王小艳', 10, '2019-12-09 00:00:00', '2019-12-09 00:00:00', 4.00, 100, 'finish', '', '因12月6日通卡电子发票应用服务器重启导致用户的充值记录未推送到电子发票，协助周磊补相关时间段的充值数据', '2019-12-13 10:51:32', '2019-12-13 10:51:32'),(105, 1, '建行app版本校验', '陈方华', 3, '2019-12-13 00:00:00', '2019-12-27 00:00:00', 40.00, 100, 'finish', '', '', NULL, '2019-12-27 13:32:46'),(106, 1, '日常维护', '陈方华', 3, '2019-12-13 13:17:15', '2019-12-13 00:00:00', 16.00, 100, 'finish', '', '', NULL, '2019-12-13 13:17:53'),(107, 2, '蓝牙充值订单状态处理以及数据检查', '周磊', 2, '2019-12-11 00:00:00', '2019-12-13 00:00:00', 15.00, 100, 'finish', '', '', '2019-12-13 13:50:31', '2019-12-13 13:50:31'),(108, 13, '通卡公众号H5修改', '张通榆', 8, '2019-12-09 15:00:00', '2019-12-09 18:00:00', 3.00, 100, 'finish', '', '通卡公众号交易记录界面修改', '2019-12-13 13:51:58', '2019-12-13 13:51:58'),(109, 11, '商城H5界面', '张通榆', 8, '2019-12-10 00:00:00', NULL, 16.00, 30, 'pending', '', '暂时完成原型所有界面框架', NULL, '2019-12-13 13:58:00'),(110, 5, '市民通V3.2.2&BOSS用例维护', '王小艳', 10, '2019-12-11 00:00:00', '2019-12-12 00:00:00', 8.00, 100, 'finish', '', '市民通app以及BOSS学生卡相关退款、异常状态变更等用例维护', '2019-12-13 14:09:09', '2019-12-13 14:09:09'),(111, 5, '学生卡充值、退款流程梳理', '王小艳', 10, '2019-12-12 00:00:00', NULL, 8.00, 90, 'pending', '优先市民通V3.3.0充值收费功能的用例编写及测试', '学生卡充值、退款流程梳理', NULL, '2019-12-27 14:09:48'),(112, 1, 'android推送信息', '王小艳', 10, '2019-12-12 00:00:00', NULL, 4.00, 70, 'pending', '已找到无法收到推送消息原因，但修改风险比较大，待评估', 'android端无法收到推送信息', NULL, '2019-12-20 15:23:48'),(113, 5, '通过通卡提供的学生卡对账样本维护用例', '王小艳', 10, '2019-12-12 00:00:00', '2019-12-12 00:00:00', 2.00, 0, 'pending', '对账文件样本中为敬老卡年检记录，待学生卡充值流程能正常走通，再生成正常的学生卡对账文件来完善学生卡对账用例', '', '2019-12-13 14:16:44', '2019-12-13 14:16:44'),(114, 5, 'BOSS敬老卡年检办理记录', '王小艳', 10, '2019-12-13 00:00:00', '2019-12-13 00:00:00', 2.00, 100, 'finish', '', 'BOSS敬老卡年检办理记录功能是否正常', '2019-12-13 14:19:24', '2019-12-13 14:19:24'),(116, 3, '补全部分用户电子发票交易信息丢失的数据', '周磊', 2, '2019-12-16 00:00:00', '2019-12-16 00:00:00', 7.00, 100, 'finish', '', '', '2019-12-16 12:47:06', '2019-12-16 12:47:06'),(117, 5, '老年卡年检记录APP端测试', '郑雪娅', 11, '2019-12-16 00:00:00', '2019-12-26 00:00:00', 36.00, 100, 'finish', '', '', NULL, '2019-12-25 10:46:45'),(118, 3, '协调处理电子发票pdf无法获取的问题', '周磊', 2, '2019-12-17 00:00:00', '2019-12-18 00:00:00', 8.00, 100, 'finish', '', '', '2019-12-17 13:45:42', '2019-12-17 13:45:42'),(119, 3, '电子发票数据无法同步，原因是该表空间已满', '周磊', 2, '2019-12-18 00:00:00', '2019-12-18 00:00:00', 2.00, 100, 'finish', '', '', '2019-12-18 10:30:37', '2019-12-18 10:30:37'),(120, 3, '对未同步的交易数据进行恢复，包括nfc和闪冲交易数据', '周磊', 2, '2019-12-18 00:00:00', '2019-12-19 00:00:00', 8.00, 100, 'finish', '', '', '2019-12-18 10:34:40', '2019-12-18 10:34:40'),(121, 5, '老年卡年检记录BOSS&APP用例编写', '郑雪娅', 11, '2019-12-17 00:00:00', '2019-12-18 00:00:00', 16.00, 100, 'finish', '', '', '2019-12-18 16:24:30', '2019-12-18 16:24:30'),(122, 5, '学生卡充值android测试', '郑雪娅', 11, '2019-12-18 00:00:00', NULL, NULL, 5, 'pending', '暂停', '', NULL, '2019-12-26 10:38:14'),(123, 2, '日常任务', '唐婷婷', 4, '2019-12-16 00:00:00', '2019-12-20 00:00:00', 2.00, 100, 'finish', '', '商户，网点，终端相关数据查询', NULL, '2019-12-27 13:28:59'),(124, 5, '学生卡接口对接', '江路', 13, '2019-12-16 10:00:00', '2019-12-17 18:00:00', 8.00, 100, 'finish', '', '', '2019-12-19 09:24:13', '2019-12-19 09:24:13'),(125, 5, '学生卡充值IOS测试', '郑雪娅', 11, '2019-12-20 00:00:00', NULL, NULL, 5, 'pending', '暂停', '', NULL, '2019-12-26 10:38:23'),(126, 5, '参与交通卡网点相关需求宣讲', '王小艳', 10, '2019-12-16 00:00:00', '2019-12-16 00:00:00', 1.00, 100, 'finish', '', '市民通APP交通卡网点需求、市民通BOSS交通卡网点需求', '2019-12-20 15:25:23', '2019-12-20 15:25:23'),(127, 1, '添加银行卡逻辑讨论', '王小艳', 10, '2019-12-16 00:00:00', '2019-12-16 00:00:00', 3.00, 100, 'finish', '', '因银联关闭开通全付通业务，导致线上用户在进行手机交通卡删卡，添加银行卡时无法跳转至银联界面开通全付通完成添卡，导论添加银行卡的更改逻辑', NULL, '2019-12-20 15:33:11'),(128, 1, '乘车码测试', '王小艳', 10, '2019-12-16 00:00:00', '2019-12-16 00:00:00', 2.00, 100, 'finish', '', '线上环境android乘车码：新用户开卡、交保证金、新用户及老用户的二维码刷卡，保证金扣款、补足保证金流程测试，流程均正常', '2019-12-20 15:29:22', '2019-12-20 15:29:22'),(129, 5, '交通卡闪充网点测试用例', '王小艳', 10, '2019-12-17 00:00:00', '2019-12-19 00:00:00', 16.00, 100, 'finish', '', '1.市民通APP交通卡闪充网点测试用例\n2.市民通BOSS交通卡闪充网点测试用例', '2019-12-20 15:30:28', '2019-12-20 15:30:28'),(130, 1, '添加银行卡测试及线上验证', '王小艳', 10, '2019-12-17 00:00:00', '2019-12-17 00:00:00', 6.00, 100, 'finish', '', '添加银行卡逻辑修改为四要素验证通过后不再跳转银联界面，直接跳转添加成功页，测试正常添加银行卡、坏机退款时添卡、手机交通卡删卡时添卡以及上线后的验证', NULL, '2019-12-20 15:34:21'),(131, 10, '导出11月份NFC写卡成功无交易检索号数据', '汤宗卫', 1, '2019-12-17 11:30:00', '2019-12-17 12:00:00', 0.50, 100, 'finish', '', '', '2019-12-20 15:33:34', '2019-12-20 15:33:34'),(132, 10, '订正2019年12月18日财务手动退款交易订单状态', '汤宗卫', 1, '2019-12-19 17:30:00', '2019-12-19 18:00:00', 0.50, 100, 'finish', '', '', '2019-12-20 15:35:41', '2019-12-20 15:35:41'),(133, 5, '市民通BOSS交通卡网点管理测试', '王小艳', 10, '2019-12-20 00:00:00', '2019-12-23 00:00:00', 11.00, 100, 'finish', '', '交通卡网点管理中“闪充网点”新增服务类型及统计数据', NULL, '2019-12-27 14:09:04'),(134, 1, '新增H5界面', '张通榆', 8, '2019-12-16 14:00:00', '2019-12-16 16:00:00', 2.00, 100, 'finish', '', '新增添加银行卡成功提示页面', '2019-12-20 15:36:41', '2019-12-20 15:36:41'),(135, 5, '交通卡闪充网点优化', '汤宗卫', 1, '2019-12-18 09:00:00', '2019-12-20 12:00:00', 19.00, 100, 'finish', '', '', NULL, '2019-12-20 15:38:18'),(136, 13, '官网修改', '张通榆', 8, '2019-12-18 14:00:00', '2019-12-18 18:00:00', 4.00, 100, 'finish', '', '修改官网底部样式及连接', '2019-12-20 15:39:24', '2019-12-20 15:39:24'),(137, 1, '四要素认证变更', '陈方华', 3, '2019-12-16 00:00:00', '2019-12-20 00:00:00', 8.00, 100, 'finish', '', '', '2019-12-20 17:18:38', '2019-12-20 17:18:38'),(138, 1, '日常维护', '陈方华', 3, '2019-12-16 00:00:00', '2019-12-20 00:00:00', 32.00, 100, 'finish', '', '', '2019-12-20 17:20:51', '2019-12-20 17:20:51'),(139, 1, '闪充网点', '何奎', 5, '2019-12-16 00:00:00', '2019-12-20 00:00:00', NULL, 100, 'finish', '', '已经上线', NULL, '2019-12-27 17:18:03'),(140, 2, '蓝牙sdk错误异常排查', '周磊', 2, '2019-12-23 00:00:00', '2019-12-23 00:00:00', 8.00, 100, 'finish', '', '', '2019-12-23 09:50:32', '2019-12-23 09:50:32'),(141, 2, '排查闪充充值无法退款的问题', '周磊', 2, '2019-12-25 00:00:00', '2019-12-25 00:00:00', 2.00, 100, 'finish', '', '', '2019-12-25 14:09:48', '2019-12-25 14:09:48'),(142, 2, '通卡闪充测试环境数据库无法联通', '周磊', 2, '2019-12-26 00:00:00', '2019-12-26 00:00:00', 5.00, 100, 'finish', '', '', '2019-12-25 15:54:45', '2019-12-25 15:54:45'),(143, 2, '充值收费版本用例编写', '郑雪娅', 11, '2019-12-26 00:00:00', '2019-12-31 00:00:00', 28.00, 100, 'finish', '', '', NULL, '2020-01-03 14:54:44'),(144, 2, '补登充值平台添加服务费支持', '周磊', 2, '2019-12-26 00:00:00', '2019-12-27 00:00:00', 16.00, 100, 'finish', '', '', '2019-12-26 14:19:33', '2019-12-26 14:19:33'),(145, 2, '通卡idc机房迁移上线工作', '周磊', 2, '2019-12-27 00:00:00', '2019-12-28 00:00:00', 16.00, 100, 'finish', '', '', '2019-12-27 11:34:35', '2019-12-27 11:34:35'),(146, 2, '通卡测试环境更新处理', '周磊', 2, '2019-12-27 00:00:00', '2019-12-27 00:00:00', 5.00, 100, 'finish', '', '', '2019-12-27 11:35:02', '2019-12-27 11:35:02'),(147, 2, 'idc机房迁移', '唐婷婷', 4, '2019-12-27 00:00:00', '2020-01-04 00:00:00', 14.00, 100, 'finish', '', 'idc机房迁移，图片相关处理', NULL, '2020-01-06 09:57:54'),(148, 10, '交通卡闪充网点优化，测试和上线', '汤宗卫', 1, '2019-12-23 09:00:00', '2019-12-24 12:00:00', 5.00, 100, 'finish', '', '', '2019-12-27 13:32:24', '2019-12-27 13:32:24'),(149, 1, '充值收费改造', '陈方华', 3, '2019-12-23 00:00:00', '2020-01-03 13:32:07', 40.00, 100, 'finish', '', '', NULL, '2020-01-03 13:32:16'),(150, 1, '用户、绑卡信息增量上报', '陈方华', 3, '2019-12-23 00:00:00', '2020-01-03 13:31:48', 34.00, 100, 'finish', '', '', NULL, '2020-01-03 13:32:01'),(151, 10, '公交卡收费规则', '唐婷婷', 4, '2019-12-25 00:00:00', NULL, 33.00, 99, 'run', '', '公交卡收费规则管理，测试完成，待上线', NULL, '2020-01-10 11:12:56'),(152, 1, '公交卡充值收费开发：traffic接口、bigdata统计、boss查询', '汤宗卫', 1, '2019-12-25 13:30:00', '2020-01-07 09:00:00', 30.00, 100, 'finish', '', '', NULL, '2020-01-10 12:52:44'),(153, 10, 'BOSS系统详细设计文档', '唐婷婷', 4, '2019-12-23 00:00:00', NULL, 12.00, 1, 'run', '', 'BOSS系统详细设计文档，优先级低', NULL, '2020-01-03 21:23:29'),(154, 10, '导出2017年06月25日-2019年12月26日所有已支付、未退款、待写卡和写卡失败订单', '汤宗卫', 1, '2019-12-24 11:00:00', '2019-12-24 12:00:00', 1.00, 100, 'finish', '', '因boss页面导出错误，唐经理让我通过查询数据库整理后发给他。', NULL, '2019-12-27 13:40:55'),(155, 1, 'traffic配合SDKManagement和cqic-server迁移IDC机房，修改相应配置', '汤宗卫', 1, '2019-12-27 09:00:00', '2019-12-27 09:30:00', 0.50, 100, 'finish', '', '', '2019-12-27 13:44:48', '2019-12-27 13:44:48'),(156, 1, '修改H5界面', '张通榆', 8, '2019-12-26 10:00:00', '2019-12-26 12:00:00', 2.00, 100, 'finish', '', '修改敬老卡年检业务介绍', NULL, '2019-12-27 13:46:12'),(157, 6, '建行升级提示上线测试', '郑雪娅', 11, '2019-12-27 00:00:00', '2019-12-27 00:00:00', 2.00, 100, 'finish', '', '', NULL, '2020-01-03 14:54:12'),(158, 1, '学生卡收费', '王映刚', 6, '2019-12-27 00:00:00', NULL, 23.00, 25, 'run', '', '学生卡收费改造开始中', NULL, '2020-01-10 16:57:18'),(159, 1, '新增H5界面', '张通榆', 8, '2019-12-27 09:00:00', '2020-01-03 18:00:00', 24.00, 100, 'finish', '', '新增收费服务协议和收费规则界面', NULL, '2020-01-03 15:14:17'),(160, 13, '交通卡查询用户日志', '张通榆', 8, '2019-12-24 09:00:00', '2019-12-24 18:00:00', 8.00, 100, 'finish', '', '交通卡余额查询生成用户日志', '2019-12-27 13:52:18', '2019-12-27 13:52:18'),(161, 1, '闪充充值收费', '郭威', 7, '2019-12-25 00:00:00', '2020-01-07 00:00:00', 40.00, 85, 'run', '', '', NULL, '2020-01-10 17:00:17'),(162, 1, '商户版充值收费', '郭威', 7, '2019-12-25 00:00:00', '2020-01-07 00:00:00', 40.00, 90, 'run', '', '已打正式包', NULL, '2020-01-10 17:00:41'),(163, 1, '市民通V3.2.2测试及上线', '王小艳', 10, '2019-12-24 00:00:00', '2019-12-25 00:00:00', 13.00, 100, 'finish', '', '市民通V3.2.2交通卡闪充网点新增服务类型及查询功能的测试、魅族删卡、老版本兼容测试和线上验证', NULL, '2019-12-27 14:13:02'),(164, 1, '参与市民通V3.3.0需求宣讲', '王小艳', 10, '2019-12-25 00:00:00', '2019-12-25 00:00:00', 2.00, 100, 'finish', '', '市民通V3.3.0充值收费需求及功能逻辑讨论', NULL, '2019-12-27 14:14:37'),(165, 1, '市民通V3.3.0测试用例编写', '王小艳', 10, '2019-12-26 00:00:00', '2019-12-30 00:00:00', 20.00, 100, 'finish', '', '市民通V3.3.0测试用例：收费服务协议、NFC贴卡充值、交通卡闪充、写卡成功、充值查询、充值退款、以及涉及到金额相关和账单、消息、电子发票', NULL, '2020-01-03 14:54:34'),(166, 5, '市民通BOSS上线及验证', '王小艳', 10, '2019-12-24 00:00:00', '2019-12-24 00:00:00', 2.00, 100, 'finish', '', 'BOSS上线功能：交通卡网点管理、老年卡年检记录', NULL, '2019-12-27 14:19:58'),(167, 5, '老年卡年检业务介绍变更', '任如娟', 9, '2019-12-26 13:00:00', '2019-12-26 18:00:00', 2.00, 100, 'finish', '', '老年卡年检业务介绍H5页面内容变更并上线', '2019-12-27 16:35:36', '2019-12-27 16:35:36'),(168, 1, '重庆市民通AndroidV3.2.2上线测试', '任如娟', 9, '2019-12-24 09:00:00', '2019-12-26 18:00:00', 8.00, 100, 'finish', '', '1.魅族删卡\n2.老年卡年审记录保存\n3.闪充网点分类\n4.老年卡年审时间未到提示优化', '2019-12-27 16:38:57', '2019-12-27 16:38:57'),(169, 1, '充值收费', '何奎', 5, '2019-12-25 00:00:00', '2019-12-30 00:00:00', 60.00, 100, 'finish', '', '打包加固', NULL, '2020-01-10 11:12:09'),(170, 2, '排查闪充充值交易明细统计无数据问题', '周磊', 2, '2019-12-31 00:00:00', '2019-12-31 00:00:00', 2.00, 100, 'finish', '', '', '2019-12-31 09:39:47', '2019-12-31 09:39:47'),(171, 2, 'NFC_sdk测试环境处理', '周磊', 2, '2019-12-31 00:00:00', '2019-12-31 00:00:00', 3.00, 100, 'finish', '', '', '2019-12-31 11:01:56', '2019-12-31 11:01:56'),(172, 2, '处理通卡闪重测试环境以及cqicserver\\manager', '周磊', 2, '2019-12-31 00:00:00', '2019-12-31 00:00:00', 5.00, 100, 'finish', '', '', '2019-12-31 15:05:05', '2019-12-31 15:05:05'),(174, 1, '公交卡充值收费联调、修改bug', '汤宗卫', 1, '2020-01-02 09:00:00', '2020-01-07 12:00:00', 16.00, 100, 'finish', '', '', NULL, '2020-01-10 12:52:33'),(175, 1, '配合idc迁移', '陈方华', 3, '2019-12-30 00:00:00', '2020-01-10 11:11:20', 32.00, 100, 'finish', '', '', NULL, '2020-01-10 11:11:31'),(176, 1, '日常维护', '陈方华', 3, '2019-12-30 00:00:00', '2020-01-03 13:34:47', 20.00, 100, 'finish', '', '', '2020-01-03 13:34:59', '2020-01-03 13:34:59'),(177, 10, '运营需求：统计19年12月充值数据（按手机号、卡号、次数等等）', '汤宗卫', 1, '2020-01-02 13:30:00', '2020-01-02 16:00:00', 2.50, 100, 'finish', '', '', NULL, '2020-01-03 13:38:34'),(178, 10, '财务需求：导出19年11.1-30号飞充已写卡的订单', '汤宗卫', 1, '2019-12-30 14:00:00', '2019-12-30 15:00:00', 1.00, 100, 'finish', '', '', NULL, '2020-01-03 13:38:24'),(179, 1, 'V3.3.0充值收费IOS版测试', '郑雪娅', 11, '2019-12-31 00:00:00', NULL, 40.00, 90, 'run', '', '', NULL, '2020-01-08 10:02:45'),(180, 10, 'V3.2.0boss充值收费相关功能测试', '郑雪娅', 11, '2019-12-31 00:00:00', NULL, 40.00, 90, 'run', '', '', NULL, '2020-01-08 10:02:53'),(181, 1, '测试环境调试', '王小艳', 10, '2019-12-30 00:00:00', '2019-12-31 00:00:00', 5.00, 100, 'finish', '', 'idc测试环境将切换回正式环境，将测试环境切换回原来的测试环境进行充值写卡调试', '2020-01-03 15:02:25', '2020-01-03 15:02:25'),(182, 1, '隐私政策H5界面', '张通榆', 8, '2020-01-03 13:00:00', '2020-01-03 15:00:00', 2.00, 100, 'finish', '', '新增重庆市民通用户隐私保护政策H5页面', '2020-01-03 15:16:11', '2020-01-03 15:16:11'),(183, 13, '交通卡查询频率限制', '张通榆', 8, '2020-01-02 09:00:00', '2020-01-08 18:00:00', 16.00, 100, 'finish', '', '交通卡查询接口调用频率限制', NULL, '2020-01-10 13:40:23'),(184, 1, '市民通V3.3.0测试', '王小艳', 10, '2019-12-31 00:00:00', '2020-01-08 00:00:00', 32.00, 100, 'finish', '', '1.市民通V3.3.0充值收费相关功能\n2.bug验证\n3.回归测试\n4.线上包验证', NULL, '2020-01-10 14:10:32'),(185, 2, '补登后台1.4版本测试', '王小艳', 10, '2020-01-03 00:00:00', '2020-01-07 00:00:00', 8.00, 100, 'finish', '', '补登1.4版本功能：交易记录、公交充值交易明细统计功能测试', NULL, '2020-01-10 14:03:48'),(186, 2, '通卡idc机房迁移', '周磊', 2, '2020-01-03 00:00:00', '2020-01-03 00:00:00', 8.00, 100, 'finish', '', '', '2020-01-03 22:38:20', '2020-01-03 22:38:20'),(187, 2, '日常任务', '唐婷婷', 4, '2020-01-06 00:00:00', '2020-01-10 00:00:00', 20.00, 100, 'finish', '', 'cqic-boss平台校验；线上交易统计1月3日数据维护;测试上的问题处理；线上导数据问题排查；机具初始化处理', NULL, '2020-01-10 11:14:13'),(188, 1, '日常任务', '唐婷婷', 4, '2020-01-06 00:00:00', '2020-01-07 00:00:00', 1.00, 100, 'finish', '', '广告平台线上维护', NULL, '2020-01-10 11:14:26'),(189, 2, '运营统计sql  充值成功，不是商户版的，时间范围', '周磊', 2, '2020-01-07 00:00:00', '2020-01-07 00:00:00', 3.00, 100, 'finish', '', '', '2020-01-07 11:40:01', '2020-01-07 11:40:01'),(190, 2, '处理服务费导出功能', '周磊', 2, '2020-01-07 00:00:00', '2020-01-08 00:00:00', 5.00, 100, 'finish', '', '', '2020-01-07 11:40:38', '2020-01-07 11:40:38'),(191, 5, 'V1.3.0商户版充值收费IOS包测试', '郑雪娅', 11, '2020-01-06 00:00:00', NULL, 32.00, 85, 'run', '', '', '2020-01-08 10:03:58', '2020-01-08 10:03:58'),(192, 2, '迁机房测试', '郑雪娅', 11, '2020-01-03 00:00:00', '2020-01-03 00:00:00', 12.00, 100, 'finish', '', '', '2020-01-08 10:10:03', '2020-01-08 10:10:03'),(193, 6, '充值收费兼容建行sdk测试', '郑雪娅', 11, '2020-01-07 00:00:00', NULL, 16.00, 90, 'run', '', '', '2020-01-08 10:10:56', '2020-01-08 10:10:56'),(194, 2, '通卡收单平台超时故障配合排查', '周磊', 2, '2020-01-09 00:00:00', '2020-01-09 00:00:00', 3.00, 100, 'finish', '', '', '2020-01-09 09:26:44', '2020-01-09 09:26:44'),(195, 2, '运营统计数据处理', '周磊', 2, '2020-01-09 00:00:00', '2020-01-09 00:00:00', 5.00, 100, 'finish', '', '', '2020-01-09 09:27:11', '2020-01-09 09:27:11'),(196, 1, '处理nfc写卡异常', '陈方华', 3, '2020-01-06 00:00:00', '2020-01-10 11:12:18', 6.00, 100, 'finish', '', '', '2020-01-10 11:12:30', '2020-01-10 11:12:30'),(197, 1, '华为内置公交卡', '何奎', 5, '2020-01-08 00:00:00', '2020-01-10 00:00:00', 32.00, 50, 'run', '', '跟进最新调整，处理线上问题', '2020-01-10 11:13:11', '2020-01-10 11:13:11'),(198, 1, '配合测试充值收费', '陈方华', 3, '2020-01-06 00:00:00', '2020-01-10 11:13:03', 16.00, 100, 'finish', '', '', '2020-01-10 11:13:12', '2020-01-10 11:13:12'),(199, 1, '日常维护', '陈方华', 3, '2020-01-06 00:00:00', '2020-01-10 11:13:41', 24.00, 100, 'finish', '', '', '2020-01-10 11:13:51', '2020-01-10 11:13:51'),(200, 1, '闪充商户版充值收费', '何奎', 5, '2020-01-01 00:00:00', '2020-01-10 00:00:00', 40.00, 100, 'finish', '', '闪充商户版-收费功能-在线充值服务平台', '2020-01-10 11:15:42', '2020-01-10 11:15:42'),(201, 1, '学生卡充值联调、修改bug', '汤宗卫', 1, '2020-01-08 09:00:00', '2020-01-17 18:00:00', 16.00, 50, 'run', '', '', '2020-01-10 12:54:22', '2020-01-10 12:54:22'),(202, 10, '运营需求：bigdata重跑17-19年公交卡充值明细统计', '汤宗卫', 1, '2020-01-06 14:00:00', '2020-01-06 18:00:00', 4.00, 100, 'finish', '', '', '2020-01-10 12:56:31', '2020-01-10 12:56:31'),(203, 10, '财务需求：统计截止19年12月相关金额总和（待写卡、写卡中、写卡失败）', '汤宗卫', 1, '2020-01-07 14:00:00', '2020-01-07 15:00:00', 1.00, 100, 'finish', '', '', '2020-01-10 13:00:38', '2020-01-10 13:00:38'),(204, 10, '运营需求：提供手机交通卡充值报10605错误数据', '汤宗卫', 1, '2020-01-10 09:00:00', '2020-01-10 12:00:00', 3.00, 100, 'finish', '', '', '2020-01-10 13:01:50', '2020-01-10 13:01:50'),(205, 13, '增加黑名单', '张通榆', 8, '2020-01-09 09:00:00', '2020-01-09 18:00:00', 8.00, 100, 'finish', '', '通卡接口访问增加黑名单', NULL, '2020-01-10 13:42:05'),(206, 13, '修改产品中心tab切换问题', '张通榆', 8, '2020-01-10 09:00:00', '2020-01-10 12:00:00', 3.00, 100, 'finish', '', '修改通卡公众号H5界面产品中心tab切换返回显示问题', '2020-01-10 13:44:28', '2020-01-10 13:44:28'),(207, 13, '修改通卡官网', '张通榆', 8, '2020-01-10 09:00:00', '2020-01-10 12:00:00', 3.00, 100, 'finish', '', '通卡官网底部新增营业执照和渝公网安备', NULL, '2020-01-10 15:07:12'),(208, 2, '闪充商户版v1.4.0功能测试', '王小艳', 10, '2020-01-07 00:00:00', '2020-01-09 00:00:00', 16.00, 100, 'finish', '', '1.闪充商户版V1.4.0充值收费功能测试\n2.回归测试\n3.线上包验证', '2020-01-10 14:07:58', '2020-01-10 14:07:58'),(209, 2, '补登平台线上问题处理及跟进', '王小艳', 10, '2020-01-07 00:00:00', '2020-01-07 00:00:00', 3.00, 100, 'finish', '', '1.因1月4日凌晨迁机房服务暂停，导致补登后台“充值明细统计”未统计1月3日的数据，手动将该天的数据统计后更新至数据库\n2.通卡反馈补登后台“闪充运营数据统计”无法导出，经测试导出功能正常，考虑通卡网络原因导致', '2020-01-10 14:16:16', '2020-01-10 14:16:16'),(210, 1, '协助验证市民通线上充值异常问题', '王小艳', 10, '2020-01-09 00:00:00', '2020-01-09 00:00:00', 2.00, 100, 'finish', '', '因调用通卡收单服务超时，导致9号上午8点半左右线上充值无法写卡，协助测试及验证', '2020-01-10 14:20:32', '2020-01-10 14:20:32'),(211, 13, '通卡微信公众号增加黑名单', '王小艳', 10, '2020-01-09 00:00:00', '2020-01-10 00:00:00', 3.00, 100, 'finish', '', '1.线上发现有用户恶意调用通卡相关接口，增加用户黑名单限制功能测试\n2.上线验证', '2020-01-10 14:22:36', '2020-01-10 14:22:36'),(212, 10, '市民通BOSS学生卡相关功能测试', '王小艳', 10, '2020-01-10 00:00:00', NULL, NULL, 30, 'run', '', '学生卡相关功能', '2020-01-10 14:23:52', '2020-01-10 14:23:52'),(213, 3, '处理电子发票线上开票后未收到已开pdf问题', '周磊', 2, '2020-01-13 00:00:00', '2020-01-13 00:00:00', 5.00, 100, 'finish', '', '', '2020-01-13 11:14:22', '2020-01-13 11:14:22'),(214, 3, '电子发票新邮件配置调整，测试、压测', '周磊', 2, '2020-01-13 00:00:00', '2020-01-14 00:00:00', 8.00, 100, 'finish', '', '', '2020-01-13 15:27:01', '2020-01-13 15:27:01'),(215, 13, '修改官网底部', '张通榆', 8, '2020-01-17 15:00:00', '2020-01-17 18:00:00', 3.00, 100, 'finish', '', '修改官网底部信息', '2020-01-17 18:08:15', '2020-01-17 18:08:15'),(216, 1, '修改H5内容', '张通榆', 8, '2020-01-16 14:00:00', '2020-01-16 18:00:00', 4.00, 100, 'finish', '', '修改市民通 NFC业务说明内容和收费协议内容修改', '2020-01-17 18:09:41', '2020-01-17 18:09:41');
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `jlcon_myproject`.`team_leave` WRITE;
DELETE FROM `jlcon_myproject`.`team_leave`;
INSERT INTO `jlcon_myproject`.`team_leave` (`id`,`start_time`,`end_time`,`user_name`,`leave_type`,`reason`,`create_time`,`update_time`) VALUES (2, '2019-11-20 12:00:00', '2019-11-20 18:00:00', '郭威', 'normal', '家里装修量柜子尺寸', '2019-11-20 14:18:30', '2019-12-09 15:52:46'),(3, '2019-11-22 16:00:00', '2019-11-22 18:00:00', '周磊', 'huanxiu', '双十一买了家具，家具到了回家弄家具', '2019-11-22 16:09:01', '2019-11-22 16:13:10'),(4, '2019-11-22 16:00:00', '2019-11-22 18:00:00', '唐婷婷', 'huanxiu', '接娃儿放学', '2019-11-22 16:13:54', '2019-11-22 16:14:03'),(6, '2019-11-26 09:00:00', '2019-11-26 12:00:00', '李鹏', 'huanxiu', '“带娃儿去种疫苗，本来是我老婆和我妈带去打的，我妈头晕又犯了，只有我和我老婆带去打了”', '2019-11-26 12:56:10', '2019-12-11 11:36:17'),(7, '2019-11-29 00:30:00', '2019-11-29 18:00:00', '汤宗卫', 'bingjia', '眼睛充血，去医院', '2019-11-29 11:41:49', '2019-12-04 17:31:33'),(8, '2019-12-04 09:00:00', '2019-12-04 12:00:00', '王映刚', 'huanxiu', '带娃儿打育苗', '2019-12-03 17:33:04', '2019-12-03 17:33:28'),(9, '2019-12-04 04:00:00', '2019-12-04 18:00:00', '汤宗卫', 'bingjia', '牙龈疼，去医院', '2019-12-04 15:45:00', '2019-12-04 17:31:41'),(10, '2019-12-05 09:00:00', '2019-12-05 18:00:00', '唐婷婷', 'bingjia', '皮肤病，去医院', '2019-12-04 17:30:31', '2019-12-04 17:31:21'),(11, '2019-12-09 16:00:00', '2019-12-09 18:00:00', '郭威', 'normal', '装修', '2019-12-09 15:52:20', '2019-12-09 15:52:20'),(12, '2019-12-10 17:00:00', '2019-12-10 18:00:00', '李鹏', 'huanxiu', '', '2019-12-11 09:43:40', '2019-12-11 09:43:40'),(13, '2019-12-11 09:00:00', '2019-12-11 18:00:00', '李鹏', 'nianjia', '“我明天要请一天假，我妈现在在医院做检查，明天还要在医院去检查，我要在屋头看到娃儿，今天我还要请一个小时假早点回去看娃儿”', '2019-12-11 09:47:46', '2019-12-11 11:30:28'),(14, '2019-12-13 08:00:00', '2019-12-13 18:00:00', '任如娟', 'nianjia', '', '2019-12-11 12:03:46', '2019-12-11 12:03:46'),(15, '2019-12-16 09:00:00', '2019-12-16 18:00:00', '任如娟', 'nianjia', '', '2019-12-11 12:04:45', '2019-12-11 12:04:45'),(16, '2019-12-13 09:00:00', '2019-12-13 18:00:00', '郑雪娅', 'nianjia', '', '2019-12-13 13:36:46', '2019-12-13 13:36:46'),(17, '2019-12-13 13:30:00', '2019-12-13 18:00:00', '陈方华', 'nianjia', '娃儿不好，带去看医生', '2019-12-13 13:37:47', '2019-12-13 13:37:47'),(18, '2019-12-30 09:00:00', '2019-12-31 18:00:00', '王映刚', 'nianjia', '朋友结婚，开婚车', '2019-12-13 14:12:07', '2019-12-13 14:12:07'),(19, '2019-12-16 13:00:00', '2019-12-16 18:00:00', '周磊', 'huanxiu', '娃娃幼儿园有事', '2019-12-16 09:41:56', '2019-12-16 09:41:56'),(20, '2019-12-17 13:30:00', '2019-12-17 18:00:00', '汤宗卫', 'huanxiu', '办贷款', '2019-12-17 13:37:27', '2019-12-17 13:37:27'),(21, '2019-12-18 16:00:00', '2019-12-18 18:00:00', '李鹏', 'normal', '', '2019-12-19 09:20:28', '2019-12-19 09:20:28');
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `jlcon_myproject`.`user` WRITE;
DELETE FROM `jlcon_myproject`.`user`;
INSERT INTO `jlcon_myproject`.`user` (`id`,`user_name`,`email`,`password`,`nick`,`position`,`phone`,`is_locked`,`user_role_id`,`person_status`,`sex`,`create_time`,`update_time`) VALUES (1, 'tangzw', NULL, '8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92', '汤宗卫', 'Java工程师', '18623102540', 'NO', 5, 'zaizhi', 'male', '2019-11-19 14:46:07', '2019-12-08 22:02:56'),(2, 'zhoulei', NULL, '8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92', '周磊', 'Java工程师', '17723692537', 'NO', 5, 'zaizhi', 'male', '2019-11-19 14:46:39', '2019-12-08 22:02:35'),(3, 'chenfh', NULL, 'ada43fa60ea5f38518a942e58f96d777c55aeac4f8999450477776e2ab6cfcc0', '陈方华', 'Java工程师', '18223383150', 'NO', 5, 'zaizhi', 'male', '2019-11-19 14:47:17', '2019-12-08 22:02:17'),(4, 'tangtt', NULL, '5748a25086c554c1cf8f1bf98ad103a52cf6e111ccd0c2e50e23258628011659', '唐婷婷', 'Java工程师', '13983618538', 'NO', 5, 'zaizhi', 'female', '2019-11-19 14:47:51', '2019-12-08 22:01:55'),(5, 'hekui', NULL, '8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92', '何奎', 'Android工程师', '18696930256', 'NO', 5, 'zaizhi', 'male', '2019-11-19 14:48:52', '2019-12-08 22:01:32'),(6, 'wangyg', NULL, '8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92', '王映刚', 'Android工程师', '18702318578', 'NO', 5, 'zaizhi', 'male', '2019-11-19 14:49:21', '2019-12-08 22:01:09'),(7, 'guowei', NULL, '8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92', '郭威', 'IOS工程师', '', 'NO', 5, 'zaizhi', 'male', '2019-11-19 14:49:44', '2019-12-05 14:36:18'),(8, 'zhangty', NULL, '8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92', '张通榆', 'H5工程师', '', 'NO', 5, 'zaizhi', 'male', '2019-11-19 14:51:06', '2019-12-05 14:36:19'),(9, 'renrj', NULL, '8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92', '任如娟', '测试主管', '18723568681', 'NO', 5, 'zaizhi', 'female', '2019-11-19 14:52:18', '2019-12-08 21:59:20'),(10, 'wangxy', NULL, '8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92', '王小艳', '测试工程师', '', 'NO', 5, 'zaizhi', 'female', '2019-11-19 14:52:49', '2019-12-05 14:36:21'),(11, 'zhengxy', NULL, '8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92', '郑雪娅', '测试工程师', '15215020424', 'NO', 5, 'zaizhi', 'female', '2019-11-19 14:53:19', '2019-12-08 21:57:33'),(12, 'lipeng', NULL, '8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92', '李鹏', '运维工程师', '17783495737', 'NO', 5, 'zaizhi', 'male', '2019-11-20 15:39:17', '2019-12-08 21:57:06'),(13, 'jlcon', NULL, '8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92', '江路', '技术总监', '15923325427', 'NO', 1, 'zaizhi', 'male', '2019-11-21 14:41:10', '2019-12-05 23:14:09');
UNLOCK TABLES;
COMMIT;
